How to: Require data in a field.
Solution:
In the Table Design view, use the 'Required' table property box in the 'Table Properties' window to require data in a field.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Select the desired table from the list box. (The selected table is highlighted.)
4) Click 'Design'. (The selected table appears in Design view)
5) Click on the field which requires data. (The property sheet appears at the bottom of the screen.)
6) Click on the 'Required' box in the 'Field Properties' window. (A down arrow appears.)
7) Click down arrow. (A drop-down list appears.)
8) Select 'Yes' from the 'Required' drop-down list.
9) Select the 'File' menu and select 'Save' to save the table.
